Skip to main content

AR Transaction Import

By using the AR Transaction Import utility, you can import an Excel spreadsheet with payment details to fulfill multiple invoices at one time.

Before Starting​

Before using the utility, you need to do the following:

  • Enable the AR Transactions Import security option.
  • Create an Excel file that includes all of the invoice payment details.

To Enable the Security Option​

  1. Go to Tools > System Maintenance. On the Tables tab, select User Security, and then click Open.

  2. Select a User Group from the list, and then click Security.

  3. In the Keyword search box, enter AR TRANSACTIONS. Select AR Transactions Import.

    img

  4. Click OK.

Excel File Example​

img

Starting the Utility​

  1. Go to AR > Utilities > AR Transaction Import.

  2. Click the Browse button and select your Excel file.

    img

  3. Enter the starting line number (default is 2).

  4. Select the Payment Type.

  5. Map the Excel file columns.

    img

  6. Preview the import or click OK to run the utility.

After the AR Import is complete, you can run an A/R Posting to preview the applied payments.

See Also​